NEW
Font size
WorksheetsExcel Quiz
Total questions: 14
Worksheet time: 28mins
Excel is a ____ program developed by Microsoft.
Spreadsheet
Document
presentation
All of the above
What is the extension of a Microsoft Excel file?
msxcl
xcl
xlsx
xlsm
The intersection of a row and a column is called a ________.
Chart
Worksheet
Cell
Sum
What is the default file name of Microsoft Excel file?
Workbook.xlsx
Workbook1.xlsx
Worksheet.xlsx
Worksheet1.xlsx
Microsoft Excel is used for ...
Analysis
Data Entry
Data Management
All of the above
Let’s say you’re trying to find your average grade. What’s wrong with the formula shown in the image?
It should use quotation marks instead of parentheses
It should have an equals sign (=) at the beginning
It should use the COUNT function instead
There is nothing wrong with the formula
Assuming cell A1 is displaying the number "12000.7789". What formula should be used to round this number to the closest integer?
=MROUND(A1,100)
=MROUND(A1,10)
=ROUND(A1,0)
=ROUND(A1,1)
The feature to center text across several cells is called:
Wrap Text
Merge and Center
Shrink to Fit
Number Formatting
What is the formula to find the lowest number in cells C1:C4?
=average(C1:C4)
=max(C1:C4)
=min(C1:C4)
=sum(C1:C4)
________ are horizontal
Rows
Columns
Which tab in Excel has charts and tables?
Review
Home
File
Insert
What is one way to ADD a Range of rows and columns in MS EXCEL other than using the + symbol.
SUMMING
Sum
Count
Average
What is the name of the cell that is colored blue?
A
B
2B
B2
Which Formula is written correctly for multiplying cell A1 and A7?
=A1+A7
=A1*A7
A1+A7
A1*A7
