stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Excel Test Flashcards | StudBud
Explore
/
Excel Test
Excel Test
25 terms
·
StudBud Administration
·
21 plays
Imported from external platform
Flashcards
25 cards
F
Practice quiz
P
Host live
L
Questions
25
Answers
1
How can you create a drop-down list in Excel?
Applying conditional Formatting
By applying Filter to the Column
Using Data Validation Feature
Using the AutoFill feature
2
Which is not an arithmetic operator in Excel
/
&
*
%
3
Which option allows you to lock certain rows or columns in place while scrolling through a large worksheet?
Freeze Columns
Lock Panes
View Panes
Freeze Panes
4
What is the purpose of the IF function in Excel?
To perform mathematical calculations
To create conditional statements
To format cells
To handle complex task
5
Which of the following is an absolute cell reference?
%
$A$2
A2
#A2
6
You can click the tabs at the bottom of a workbook to switch between ________.
Formulas
Worksheets
Rows
Permissions
7
Which is the Formula to Calculate the sum of Cell A1 through A5?
Both Red and Yellow
=Sum(A1,A5)
A1+A2+A3+A4+A5
=Sum (A1:A5)
8
Excel is an example of what type of Software program?
Word Processing
Spreadsheet
Accounts Processing
Graphics Processing
9
A group of Cells is called
Cell Range
Chart
Multicell
Cell Cluster
10
What is the meaning of this calculation operators in Excel formula: <> 10?
Not equal to 10
Smaller then 10
Only 10
In between 9 to 10
11
What are the keyboard shortcut keys to edit formula in a cell?
F4
CTRL+E
CTRL+1
F2
12
Which of the following statement is FALSE?
XLOOKUP function find things in a table or range
FILTER function filters an array based on a Boolean array
SORT returns a sorted array of the elements in an array.
Excel cannot define a name for a cell range by cell reference
13
Which of the following Excel features allows you to select/highlight all cells that are formulas?
Go To Special
Go To
Find
Replace
14
Which Logical function indicates TRUE only if all arguments are assessed as TRUE, and FALSE otherwise
AND
ANDIF
OR
IF
15
Which of the following is not a type of Alignment?
Center
Left
Right
Forward
16
What Transpose function do in Excel?
Converts a number into a text
Swaps the rows and columns in a range
Rounds a number into nearest integer
Change the Case of the Text
17
What does the term "Array Formula" mean in Excel?
A formula that performs operations on selected range of cells
A formula that uses another function
A formula that returns an array of values
A formula entered multiple cells simultaneously
18
In Microsoft Excel spreadsheets, columns are designated as
A1,B2,C1
1,2,3
A,B,C
I,II,III
19
What is the purpose of the DATEDIF function in Excel?
Checks if a date falls on a weekend
Converts a date to a specific format
Rounds a date to the nearest month
Calculates the difference between two dates
20
Which of the following formula is correct?
=FILTER(A1:B1,A2:B2>=80)
=IF(A2>80,A1,””) AND IF(B2>80,B1,””)
=XLOOKUP(Name,A:C,-1)
=COUNTA(A1:B1,”>80”)
21
Q11. In Excel, what does the term "data validation" refer to?
Protecting data from unauthorized access
Ensuring data accuracy through validation rules
Checking for Errors
Sorting data in ascending order
22
How can you merge cells in Excel?
Use “Merge & Center” Button
Use the “Merge Cells” option in the Format Menu.
Both RED And Yellow
Apply a Cell Style
23
In Excel, what does the function COUNTA() do?
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 total number of cells in a range
Counts the number of cells in a range that contain text
24
Formulas always start with
Function (e.g Sum)
Equal Sign (=)
Column name (e.g A)
Arithmetic Operators (e.g +)
25
The intersection of a row and a column is called
Sum
Work
Cell
Chart
