| CARVIEW |
- Courses
- Tutorials
- Practice
- Jobs
Excel Basics Quiz
A quiz to test your knowledge of Excel basics.
Question 1
You have an Excel workbook with 5 worksheets. Which shortcut lets you quickly switch to the next worksheet?
Ctrl + Tab
Ctrl + Page Down
Ctrl + →
Alt + Tab
Question 2
You need to share an Excel file without formulas, only raw data. Which file type is best to use?
.xlsx
.xls
.csv
.xlsm
Question 3
If a cell contains the value 44561 formatted as a date, what does it represent?
04-Jan-2022
01-Jan-2022
01-Jan-1900
04-Jan-1900
Question 4
A column contains numbers stored as text (left-aligned). Which is the fastest method to convert them to numbers?
Use TEXT()
Multiply by 1 or add 0
Change font to “Number”
Use TRIM()
Question 5
You want to restrict a column to accept only dates after 01-Jan-2023. Which feature will you use?
Conditional Formatting
Data Validation
Protect Sheet
Text to Columns
Question 6
Which custom number format will display 1234 as 1,234.00?
0.00
#,##0.00
###.##
0#,0.0
Question 7
Which formula calculates the sum of values in column B where column A equals "East"?
=SUM(B:B,"East")
=SUMIF(A:A,"East",B:B)
=IF(A:A="East",SUM(B:B))
=COUNTIF(A:A,"East")
Question 8
If your data contains zeros that you want to ignore while averaging, which formula should you use?
=AVERAGEIF(range,"<>0")
=AVERAGE(range)-0
=SUM(range)/COUNT(range)
=IF(range<>0,AVERAGE(range))
Question 9
What is the difference between COUNT and COUNTA?
COUNT counts only numbers; COUNTA counts numbers and text
COUNT counts all cells; COUNTA counts only empty cells
COUNT counts text; COUNTA counts numbers
Both count the same values
Question 10
A cell shows =SUM(A1:A3)/COUNT(A1:A3). Which statistical measure is this calculating?
Median
Average
Mode
Standard Deviation
There are 14 questions to complete.
