stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Tables, Charts and Graphs, sparklines, Freezing Panes, and View Options Flashcards | StudBud
Explore
/
Tables, Charts and Graphs, sparklines, Freezing Panes, and View Options
Tables, Charts and Graphs, sparklines, Freezing Panes, and View Options
30 terms
·
StudBud Administration
·
47 plays
Imported from external platform
Flashcards
30 cards
F
Practice quiz
P
Host live
L
Questions
30
Answers
1
Where does Santa Claus live?
North Pole
Salt Lake City
Utah
China
2
The telephone was invented by:
Alex Ferguson
Alexander G. Bell
Alexander G. Tell
Alexander Flemming
3
"LMK" means _______________.
Let Me Know
Let Me Kare
Life Memories Knowledge
Love More Knowledge
4
What feature in Excel allows you to organize data in rows and columns?
Freeze Panes
Sparklines
Tables
Charts
5
What color is an Emerald?
Green
Blue
Orange
Red
6
Who was the first American president?
Weorge Gashington
Donald Trump
George Washington
Abraham Lincoln
7
A features that displays only the data in column (s) according to specified criteria
Formula
Sorting
Pivot
Filtering
8
A task that is very easy is a piece of...
the puzzle
cake
pie
the ship's command center
9
Which state is famous for Hollywood?
Virgina
Florida
Texas
California
10
What is the purpose of using AND or OR operators within an IF function in Excel?
To use logical operators in place of numerical values in the IF function.
To format the output of the IF function based on specific conditions.
To perform mathematical calculations on the results of the IF function.
To combine multiple IF conditions and check if all or any of them are true.
11
Statistical calculations and preparation of tables and graphs can be done using
Adobe Photoshop
Excel
Word
Power Point
12
When using mathematical functions in Excel, what does the term "syntax" refer to?
The way data is organized in the worksheet.
The mathematical operations involved in the function.
The structure and rules for writing the formula correctly.
The arrangement of cells in a range.
13
Which country's political leader is paid the highest?
Singapore
Guatemala
USA
Hong Kong
14
Which Excel function should you use to calculate the sum of a range based on a single criterion?
SumIf
AverageIf
MaxIf
CountIf
15
Can you name the closest star to Earth?
Mars
The Moon
The sun
Jupiter
16
What type of chart is useful for comparing values over categories?
Dot Graph
Column Chart
Pie Chart
Line Chart
17
What is the purpose of the CountIf function in Excel?
To count the number of cells meeting specific criteria.
To count the total number of cells in a range.
To calculate the average of a range.
To find the largest value in a range.
18
What do caterpillars turn into?
butterfly
bee
spider
wasp
19
In Excel, what is the purpose of using the IF function?
To perform a logical test and return different values based on the result.
To perform calculations on numeric values.
To search for specific text in a range of cells.
To format cells based on specific conditions.
20
Which Excel feature allows you to keep specific rows and columns visible while scrolling through data?
Freeze Panes
Chart Design
Sparklines
Split Worksheet
21
The intersection of a column and a row is called
Block
Cell
Reference
Active cell
22
In Excel, what is the purpose of using the OR operator within an IF function?
To reverse the output of the IF function's logical test.
To perform a series of unrelated logical tests within a single formula.
To combine multiple IF conditions using logical OR.
To negate the results of the AND operator in the IF function.
23
What is the purpose of splitting a worksheet in Excel?
To make specific rows and columns always visible while scrolling.
To lock certain cells and protect them from editing.
To hide data temporarily.
To view multiple distant parts of the worksheet at once.
24
What type of chart is useful for showing trends over time or continuous data?
Line Chart
Bar Graph
Pie Chart
Scatter Plot
25
To change the design of a chart in Excel, which tab on the ribbon contains relevant options?
Design
Home
Insert
View
26
When would you use the Nested IF function in Excel?
To create complex logical tests with multiple levels of conditions.
To perform a series of unrelated logical tests within a single formula.
To calculate mathematical averages based on specific criteria.
To combine multiple IF conditions using the AND and OR operators.
27
imo:
in my opinion
i miss obama
in my office
i'll meet outside
28
The capital of Switzerland is...
Geneva
Agno
Basel
Bern
29
Which Excel function is used to find the average of a range based on specified criteria?
SumIf
MaxIf
AverageIf
CountIf
30
What is the purpose of Sparklines in Excel?
To generate dynamic tables from the data.
To create interactive charts for presentations.
To create small, data-rich charts within individual cells.
To visualize complex data relationships.
