NEW
Font size
WorksheetsQ3 ICT07 General Quiz
Total questions: 50
Worksheet time: 25mins
What is Microsoft Excel primarily used for?
Word processing
Spreadsheet management
Video editing
Web design
What is OneDrive?
A gaming platform
A file storage and sharing service
A video conferencing app
A spreadsheet application
What do you call the vertical arrangement of data in Excel?
Row
Column
Sheet
Cell
What is the smallest unit in an Excel spreadsheet?
Row
Column
Cell
Workbook
Where do you click to select all the cells in a worksheet?
The "All button" at the top-left corner
The Home tab
Any empty cell
The Page Layout tab
How do you adjust the width of a column in Excel?
Drag the column boundary
Press Enter
Click Insert
Click Delete
What is a cell address?
The title of the worksheet
The name of the workbook
The combination of a column letter and row number
A type of table
Which tool allows you to change the background color of a cell?
Borders
Fill Color
Insert
Text Alignment
How can you add a border to a cell?
By clicking the Borders button
By clicking the Fill Color button
By pressing Enter
By deleting the cell
What happens when you click the "All button" above row 1?
It selects all cells in the worksheet
It merges all cells
It deletes the worksheet
It formats the cells
What is a worksheet?
A collection of workbooks
A collection of cells
A type of function
A formula
What do we call a collection of worksheets?
Table
Workbook
Formula
Chart
How many sheets does a new Excel workbook contain by default?
1
2
3
5
Where can you find the sheet tabs in Excel?
At the bottom of the screen
At the top-left corner
Inside the File tab
On the right side of the toolbar
How can you rename a sheet?
Double-click the sheet tab and type a new name
Click the Insert tab
Press Ctrl + S
Use the Sort function
What symbol must all Excel formulas start with?
+
=
-
*
What does the symbol (^) represent in Excel formulas?
Multiplication
Exponent
Addition
Division
How do you write an equation for addition in Excel?
=A1+A2
A1+A2=
(A1+A2)
A1/A2
How do you multiply the values of cell A1 and B1?
=A1+B1
=A1*B1
=A1-B1
=A1/B1
What does PEMDAS stand for?
Parentheses, Exponent, Multiplication, Division, Addition, Subtraction
Parentheses, Equations, Multiplication, Data, Analysis, Subtraction
Parentheses, Exponent, Measurement, Division, Algebra, Sorting
Processing, Exponent, Multiplication, Division, Addition, Sorting
What is the Excel formula for (10 + 5) × 2?
=10+5*2
=(10+5)*2
=10+(5*2)
=10+5+2
How do you represent 7² in Excel?
=7*7
=7^2
=7**2
=7²
What is the correct Excel formula for (20 ÷ 4) + 8?
=20/4+8
=20+(4/8)
=(20/4)+8
=20/4*8
How do you represent 5 × (12 - 4) in Excel?
=5*12-4
=5*(12-4)
=(5*12)-4
=5*12/4
What will Excel calculate first in this formula: =8+3*2?
8 + 3
3 * 2
8 + (3 * 2)
8 + 3 + 2
How do you start a new line within a cell?
Press Enter
Press Ctrl + Enter
Press Alt + Enter
Press Shift + Enter
What is the keyboard shortcut to save an Excel file?
Ctrl + P
Ctrl + S
Ctrl + X
Ctrl + Z
What does the Undo button do?
Deletes the workbook
Restores the last action
Saves the file
Copies data
How do you delete a row in Excel?
Click on the row number and press Delete
Right-click the row number and select Delete
Click Insert and choose Delete Row
Press Ctrl + D
How do you merge two or more cells?
Use the Merge & Center button
Press Ctrl + M
Use the Sort function
Click on Insert
How do you represent (50 - 10) ÷ 2 in Excel?
=50-10/2
=(50-10)/2
=50-(10/2)
=50/10-2
How would you write 4 × 3 + 6 ÷ 2 in Excel?
=4*3+6/2
=(4*3)+(6/2)
=(4×3)+(6÷2)
=4*(3+6)/2
What is the correct Excel formula for (25 ÷ 5) × (8 - 3)?
=25/5*8-3
=(25/5)*(8-3)
=25/(5*8)-3
=25/(5*(8-3))
How would you write 3³ in Excel?
=3*3*3
=3^3
=3³
=3×3×3
How do you represent (14 + 6) ÷ 2 × 5 in Excel?
=(14+6)/2*5
=14+6/2*5
=14+(6/2)*5
=14+6/(2*5)
How do you convert (18 - 9) × 3 into an Excel formula?
=18-9*3
=(18-9)*3
=(18*9)-3
=18-(9*3)
What will Excel calculate first in =6 + 2 × 3?
6 + 2
2 × 3
(6 + 2) × 3
6 + (2 × 3)
How do you write (100 - 50) ÷ 5 + 2 in Excel?
=100-50/5+2
=(100-50)/5+2
=100-(50/5)+2
=100-50/(5+2)
How do you write 5 × (20 - 5) ÷ 3 in Excel?
=5*20-5/3
=5*(20-5)/3
=(5*20)-5/3
=5*20-(5/3)
What is the correct Excel formula for (9 + 3) × (8 ÷ 4)?
=9+3*8/4
=(9+3)*(8/4)
=9+(3*8)/4
=9+3*(8/4)
What is the shortcut to create a new workbook in Excel?
Ctrl + N
Ctrl + S
Ctrl + P
Ctrl + X
What is the intersection of a row and a column called?
Workbook
Worksheet
Cell
Sheet
How do you move to the next cell on the right in Excel?
Press Enter
Press Tab
Press Shift
Press Ctrl
What happens if you press Ctrl + Z in Excel?
Saves the workbook
Redoes an action
Undoes the last action
Opens a new worksheet
What is the default file extension of an Excel 2016 file?
.docx
.xlsx
.pptx
.xlsm
What will happen if you press Ctrl + C in Excel?
Copy the selected content
Cut the selected content
Paste the selected content
Clear the worksheet
Which Excel tool is used to adjust the width of a column?
Merge & Center
AutoFit
Text Alignment
Conditional Formatting
Where is the Formula Bar located in Excel?
Below the Ribbon
Below the sheet tabs
On the right side of the screen
Above the title bar
How do you merge two or more cells?
Click Merge & Center
Click Sort & Filter
Use AutoFit
Use Text Wrap
What key do you press to edit the contents of a cell?
F1
F2
F3
F4
