ms excel Flashcards
What symbol is used in Excel to start a formula?
=
Example: =SUM(A1:A10)
Which function is used to calculate the average in Excel?
=AVERAGE()
Example: =AVERAGE(B1:B10)
What is the intersection of a row and a column called in Excel?
Cell
Which shortcut key is used to save an Excel workbook?
Ctrl + S
Which function returns the highest value in a range of cells?
=MAX()
Example: =MAX(C1:C10)
What does the ‘Merge & Center’ option do?
Combines multiple cells and centers the content
In Excel, which chart type is best for showing parts of a whole?
Pie chart
Which function is used to count only the numeric values in a range?
=COUNT()
Example: =COUNT(D1:D10)
What does the Fill Handle in Excel help you do?
Automatically fill cells with data or formulas
Which tab would you use to insert a chart in Excel?
Insert
Which of the following is NOT a valid data type in Excel?
d) Character
What is the shortcut to insert the current date in a cell?
b) Ctrl + ;
Which function will you use to count the number of empty cells in a range?
b) =COUNTBLANK()
What is the default number of worksheets in a new Excel workbook (modern versions)?
c) 1
Which feature is used to prevent unwanted changes to a worksheet?
c) Protect Sheet
Which function is used to join two or more strings of text in Excel?
c) =CONCATENATE() or =CONCAT()
Which cell reference type does not change when copied or filled?
b) Absolute
What does the IF function return if the condition is false?
c) FALSE
Which menu option allows you to sort data A-Z or Z-A in Excel?
d) Data
Which of the following is used to remove duplicate values in a range?
b) Data → Data Tools → Remove Duplicates
