In Excel, what does the function COUNTA() do?

Counts the number of cells in a range that are not blank

What does the term "Array Formula" mean in Excel?

A formula that performs operations on an entire range of cells

What does the term "cell" refer to in Microsoft Excel?

The intersection of a row and column

What is the purpose of the IF function in Excel?

To create conditional statements

How can you create a drop-down list in Excel?

Using the Data Validation feature

In Excel, what does the term "data validation" refer to?

Ensuring data accuracy through validation rules

studbud

Can you Excel?

15 termsStudBud Administration10 plays

Imported from external platform

Flashcards15 cardsFPractice quizPHost liveL

Questions 15

Answers

1
What would be a correct formula for SUM in excel?
=SUM(B3:B9)
=ADD(B3:B9)
SUM(B3:B9)
=SUMB3+B9
2
How do you insert a new worksheet in Excel?
Go to the "Home" tab and click "Insert Sheet"
Both A and B
Right-click on a sheet tab and choose "Insert"
Press Ctrl + N
3
Which of the following is an absolute cell reference?
=A2
A:2
$A$2
A2
4
How can you find and replace data in Excel?
Ctrl + F
All of the above
Ctrl + R
Ctrl + H
5
In Excel, what does the function COUNTA() do?
Counts the total number of cells in a range
Counts the number of cells in a range that are not blank
Counts the number of cells in a range that are greater than zero
Counts the number of cells in a range that contain text
6
What does the term "Array Formula" mean in Excel?
A formula that performs operations on an entire range of cells
A formula that uses the ARRAY function
A formula entered into multiple cells simultaneously
A formula that returns an array of values
7
Which function can you use to display a different value based on a condition?
IF
INDEX
XLOOKUP
VLOOKUP
8
What is the keyboard shortcut for copying cells in Excel?
Ctrl + A
Ctrl + Z
Ctrl + C
Ctrl + X
9
What does the term "cell" refer to in Microsoft Excel?
A formatting option
A group of worksheets
The intersection of a row and column
A type of chart
10
What is the purpose of the IF function in Excel?
To perform mathematical calculations
To format cells
To generate random numbers
To create conditional statements
11
How can you create a drop-down list in Excel?
Applying a filter to a column
Applying conditional formatting
Using the AutoFill feature
Using the Data Validation feature
12
Which of the following features allow you to narrow down the data in your worksheet?
Filtering
Sorting
Cell Reference
Merge Cell
13
In Excel, what does the term "data validation" refer to?
Checking for errors in formulas
Ensuring data accuracy through validation rules
Sorting data in ascending order
Protecting data from unauthorized access
14
Google Sheets saves your changes automatically.
True
False
15
What is the purpose of the N function in Excel?
Finds the nth largest value in a range
Rounds a number to the nearest integer
Counts the number of cells that contain numbers
Converts a value to a number

Can you Excel? Flashcards | StudBud