1

Computer BASED BUSINESS

APPLICATIONS
ACCOUNTING USING EXCEL

REEM SHAKER
ASSISTANT LECTURER | ACCOUNTING
DEPARTMENT | MANSOURA UNIVERSITY
3 Computer-Based Business Applications: Accounting using Excel
4 Second Level
5 Section 1
6

7 1. If you start a new Excel program from the start button on the Windows taskbar, its default
8 name is
9 a) New Microsoft Excel Worksheet
10 b) Document1
11 c) New Microsoft PowerPoint Presentation
12 d) Book1
13 2. If you start a new Excel program by clicking the mouse right button on the desktop, its
14 default name is
15 a) New Microsoft Excel Worksheet
16 b) Document1
17 c) New Microsoft PowerPoint Presentation
18 d) Book1
19 3. Starting a new Excel program from the start button on the Windows taskbar allows all of
20 the following except
21 a) Opening any Excel file already existed on the computer
22 b) Saving the Excel file automatically (auto-save)
23 c) Allows to select a blank workbook
24 d) Allows to choose readymade templates
25 4. Starting a new Excel program by clicking the mouse right button on the desktop allows
26 which of the following
27 a) Opening any Excel file that already existed on the computer
28 b) Saving the Excel file automatically (auto-save)
29 c) Allows to select a blank workbook or readymade templates
30 5. Which of the following is true about the close option in the file menu tap
31 a) It closes the Excel app entirely
32 b) It only closes the opened worksheet

1
33 c) a and b
34 d) None of the Above
35 6. Pressing ALT + F4 or the close button in the upper-right corner of the Excel app window
36 will
37 a) close the Excel app entirely
38 b) only close the opened worksheet
39 c) a and b
40 d) None of the Above
41 7. What happens when you try to exit Excel after working on a workbook without saving
42 your latest changes?
43 e) Excel automatically saves your changes before exiting.
44 f) Excel displays an alert box asking if you want to save your changes.
45 g) Excel exits without any warning.
46 h) Excel saves the workbook to a temporary file and asks later if you want to save.

47 8. Which of the following are valid ways to pin Excel to the taskbar in Windows?

48 a) Right-click the Excel icon in the All Apps menu and choose "Pin to Taskbar"
49 b) Open Excel, right-click its icon on the taskbar, and choose "Pin to Taskbar"
50 c) Right-click the Excel name in the All Apps menu and choose "Pin to Start"
51 d) Both A and B

52 9. To pin Excel to the Start menu in Windows..

53 a) Right-click the Excel icon in the All Apps menu and choose "Pin to Start"
54 b) Open Excel, right-click its icon on the taskbar, and choose "Pin to Start"
55 c) Drag the Excel file to the Start menu
56 d) Right-click Excel in File Explorer and select "Pin to Start"

2
57 10. According to the picture, the Excel program is
58 a) Pined to start menu & pinned to taskbar
59 b) Unpinned to start menu & unpinned to taskbar
60 c) Pined to start menu & unpinned to taskbar
61 d) Unpinned to start menu & pinned to taskbar
62 11. According to the picture, the Excel program is
63 unpinned to the taskbar
64 a) True
65 b) False
66 12. The filename and the program name (Excel) appear
67 in
68 a) The quick access toolbar
69 b) The taskbar
70 c) The title bar
71 d) The status bar
72 13. What is the default worksheet name in a new Excel workbook?

73 a) Sheet2
74 b) Sheet1
75 c) Book1
76 d) DataSheet

77 14. How can you add a new worksheet to an Excel workbook?

78 a) Right-click on the worksheet name and select "New Sheet"

79 b) Click the "+" button labeled "New Sheet"
80 c) Press Ctrl + N
81 d) Use the "Insert" menu to add a worksheet

82 15. How can you rename a worksheet in Excel?

83 a) Right-click the sheet tab and select "Rename"

84 b) Double-click the sheet name and type the new name
85 c) Right-click and choose "Properties" to rename
86 d) Go to the "File" menu and select "Rename"

3
87 16. Where are the sheet tabs located in Excel?

88 a) At the top of the workbook next to the formula bar

89 b) Just above the Status bar at the bottom of the screen
90 c) In the "Insert" menu
91 d) In the "View" tab of the ribbon

92 17. What does an Excel worksheet consist of?

93 a) A grid of sheets and formulas

94 b) A grid composed of rows, columns, and cells
95 c) A collection of charts and graphs
96 d) A table of data only

97 18. How many rows and columns are there in an Excel worksheet?

98 a) 1,000,000 rows and 16,000 columns

99 b) 1,048,576 rows and 16,384 columns
100 c) 1,024 rows and 16,000 columns
101 d) 1,000,000 rows and 1,024 columns

102 19. In an Excel worksheet, how are columns and rows identified?

103 a) Columns are identified by numbers, and rows are identified by letters.
104 b) Columns are identified by letters, and rows are identified by numbers.
105 c) Both columns and rows are identified by letters.
106 d) Both columns and rows are identified by numbers.

107 20. How is each cell in an Excel worksheet identified?

108 a) By the intersection of a row and a column, such as A1 for the first cell.
109 b) By a unique cell number assigned to each box.
110 c) By a color code assigned to each cell.
111 d) By the order in which the cell was created.

112 21. The intersection between the column B and the row 10 is
113 a) The cell 10B
114 b) The cell B
115 c) The cell B10
116 d) The cell 10

4
117 22. By default, which three Ribbon commands are included in the Quick Access toolbar in
118 Excel?

119 a) Save, Undo, Redo

120 b) Save, Copy, Paste
121 c) Undo, Redo, Print
122 d) Save, Cut, Copy

123 23. ______ in the Quick Access Toolbar saves any changes made to the current workbook
124 using the same filename, file format, and location.

125 a) Save
126 b) Undo
127 c) Redo

128 24. ______ in the Quick Access Toolbar undoes the last editing, formatting, or layout
129 change you made.

130 a) Save
131 b) Undo
132 c) Redo

133 25. ______ in the Quick Access Toolbar reapplies the previous editing, formatting, or
134 layout change that you just removed with the Undo button.

135 a) Save
136 b) Undo
137 c) Redo

138 26. You can customize the quick access toolbar by adding or removing any ribbon command as well
139 as showing the quick access toolbar below the ribbon
140 a) True
141 b) False

5
142 27. According to the picture, the quick access toolbar is
143 showed
144 a) Above the ribbon
145 b) Below the ribbon
146 28. The Formula bar displays ……………. of the
147 active cell
148 a) The address
149 b) The contents
150 c) a or b
151 d) a and b
152 29. Formula bar consists of
153 a) Name box
154 b) Formula bar buttons
155 c) Cell contents
156 d) b and c only
157 e) a, b and c
158 30. The name box of the formula bar displays ……………. of the active cell
159 a) The address
160 b) The contents
161 c) a or b
162 d) a and b
163 31. The cell content of the formula bar displays ……………. of the active cell
164 a) The address
165 b) The content
166 c) a or b
167 d) a and b
168 32. The ribbon includes 8 taps
169 a) True
170 b) False

6
171 33. Formula bar buttons contain name box, formula bar buttons and cell contents
172 a) True
173 b) False
174 - The formula bar buttons contains 3 buttons (insert function, cancel (×) and enter (√ ) buttons).
175 - The formula bar consists of 3 parts (name box, formula bar buttons and cell contents).