Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

E-Tech > MS word & excel > Flashcards

MS word & excel Flashcards

(104 cards)

Start Studying
1
Q

What is a formula in Excel?

A

A formula in Excel is an expression that calculates the value of a cell.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

True or False: Formulas in Excel always start with the equal sign (=).

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Fill in the blank: The function used to sum a range of cells is called _____.

A

SUM

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is the purpose of the AVERAGE function in Excel?

A

To calculate the average of a set of numbers.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Which function would you use to find the maximum value in a range?

A

MAX

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What does the COUNT function do?

A

It counts the number of cells that contain numbers in a range.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

True or False: You can use cell references in Excel formulas.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is the difference between absolute and relative cell references?

A

Absolute references do not change when copied, while relative references adjust based on the position.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is the syntax for the IF function?

A

IF(logical_test, value_if_true, value_if_false)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Which function would you use to concatenate text strings?

A

CONCATENATE or the ‘&’ operator.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Fill in the blank: The function to find the current date is _____.

A

TODAY()

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What does the VLOOKUP function do?

A

It looks up a value in the first column of a table and returns a value in the same row from a specified column.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

True or False: The PMT function is used to calculate loan payments.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is the purpose of the ROUND function?

A

To round a number to a specified number of digits.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Which function would you use to count non-empty cells?

A

COUNTA

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Fill in the blank: The formula to calculate the percentage increase is _____.

A

(New Value - Old Value) / Old Value

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What does the LEN function do?

A

It returns the number of characters in a text string.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What is the purpose of the INDEX function?

A

To return the value of a cell in a specified row and column of a range.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

True or False: You can nest functions within other functions in Excel.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

What is the function of the CONCAT function?

A

To join multiple text strings into one string.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

What does the NOW function return?

A

The current date and time.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Fill in the blank: The function used to find the smallest number in a range is _____.

A

MIN

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

What is the syntax for the SUMIF function?

A

SUMIF(range, criteria, [sum_range])

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

What does the MATCH function do?

A

It returns the relative position of an item in an array that matches a specified value.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
True or False: The TODAY function updates every time the worksheet is recalculated.
True
26
What is the purpose of the IFERROR function?
To return a custom value if a formula results in an error.
27
What is a formula in Excel?
A formula in Excel is an expression that calculates the value of a cell.
28
True or False: Formulas in Excel always start with the equal sign (=).
True
29
Fill in the blank: The function used to sum a range of cells is called _____.
SUM
30
What is the purpose of the AVERAGE function in Excel?
To calculate the average of a set of numbers.
31
Which function would you use to find the maximum value in a range?
MAX
32
What does the COUNT function do?
It counts the number of cells that contain numbers in a range.
33
True or False: You can use cell references in Excel formulas.
True
34
What is the difference between absolute and relative cell references?
Absolute references do not change when copied, while relative references adjust based on the position.
35
What is the syntax for the IF function?
IF(logical_test, value_if_true, value_if_false)
36
Which function would you use to concatenate text strings?
CONCATENATE or the '&' operator.
37
Fill in the blank: The function to find the current date is _____.
TODAY()
38
What does the VLOOKUP function do?
It looks up a value in the first column of a table and returns a value in the same row from a specified column.
39
True or False: The PMT function is used to calculate loan payments.
True
40
What is the purpose of the ROUND function?
To round a number to a specified number of digits.
41
Which function would you use to count non-empty cells?
COUNTA
42
Fill in the blank: The formula to calculate the percentage increase is _____.
(New Value - Old Value) / Old Value
43
What does the LEN function do?
It returns the number of characters in a text string.
44
What is the purpose of the INDEX function?
To return the value of a cell in a specified row and column of a range.
45
True or False: You can nest functions within other functions in Excel.
True
46
What is the function of the CONCAT function?
To join multiple text strings into one string.
47
What does the NOW function return?
The current date and time.
48
Fill in the blank: The function used to find the smallest number in a range is _____.
MIN
49
What is the syntax for the SUMIF function?
SUMIF(range, criteria, [sum_range])
50
What does the MATCH function do?
It returns the relative position of an item in an array that matches a specified value.
51
True or False: The TODAY function updates every time the worksheet is recalculated.
True
52
What is the purpose of the IFERROR function?
To return a custom value if a formula results in an error.
53
What function would you use in Excel to convert text to lowercase?
LOWER
54
True or False: The CONCATENATE function can combine multiple text strings into one.
True
55
Fill in the blank: The function __________ is used to find the length of a text string.
LEN
56
What does the TEXT function do in Excel?
It formats a number and converts it to text.
57
Which function would you use to extract a specific number of characters from the start of a text string?
LEFT
58
Multiple Choice: Which of the following functions returns a substring from a text string? A) MID B) SUM C) AVERAGE D) IF
A) MID
59
What is the purpose of the TRIM function in Excel?
To remove extra spaces from text.
60
True or False: The UPPER function converts all characters in a text string to uppercase.
True
61
What logical function would you use to test a condition and return one value if true and another if false?
IF
62
Fill in the blank: The function __________ checks whether a condition is met and returns TRUE or FALSE.
BOOLEAN
63
Which logical function can be used to return TRUE if all conditions are true?
AND
64
Multiple Choice: Which function is used to return TRUE if any of the conditions are true? A) IF B) OR C) NOT D) AND
B) OR
65
What does the NOT function do in Excel?
It reverses the logical value of its argument.
66
True or False: The COUNTIF function can be used to count the number of cells that meet a certain condition.
True
67
What is the syntax for the IF function in Excel?
IF(logical_test, value_if_true, value_if_false)
68
Fill in the blank: The __________ function can be nested within an IF function to provide additional logical tests.
AND/OR
69
Which function would you use to check if a specific text string is found within another text string?
SEARCH
70
What is the purpose of the FIND function in Excel?
To locate a substring within a text string, case-sensitive.
71
True or False: Excel's IFERROR function can be used to handle errors in calculations.
True
72
What does the ISBLANK function check?
It checks whether a cell is empty.
73
Multiple Choice: Which function would you use to combine text from different cells? A) CONCATENATE B) SPLIT C) JOIN D) TEXTJOIN
A) CONCATENATE
74
What is the output of the formula =IF(1=1, 'Yes', 'No')?
Yes
75
Fill in the blank: The __________ function is used to join multiple text strings with a specified delimiter.
TEXTJOIN
76
Which function returns the number of characters in a text string, including spaces?
LEN
77
True or False: The SUBSTITUTE function can replace a specific instance of a substring within a text string.
True
78
What does the VALUE function do in Excel?
It converts a text string that represents a number into a numeric value.
79
What is the purpose of the Home tab in MS Word 2013?
The Home tab provides basic text formatting options such as font styles, paragraph alignment, and clipboard functions.
80
True or False: The Insert tab allows users to add images and tables to their document.
True
81
Fill in the blank: The _____ tab contains options for page layout, including margins and orientation.
Page Layout
82
Which tab would you use to check the spelling and grammar of a document?
Review
83
What feature can you find under the View tab?
Options to change the document's view, such as Print Layout, Web Layout, and Outline.
84
Multiple Choice: Which of the following is NOT found in the Insert tab? A) Shapes B) Text Box C) Page Number D) Font Color
D) Font Color
85
What does the Design tab in MS Word 2013 allow users to do?
It allows users to apply document styles and themes for a cohesive look.
86
True or False: The File tab is where you can save, open, and print documents.
True
87
Which submenu in the Page Layout tab allows you to adjust the document's margins?
Margins submenu
88
What is the purpose of the Mailings tab?
To create and manage mail merge documents for mass mailings.
89
Fill in the blank: The _____ tab provides tools for working with references and citations.
References
90
What can you find in the Quick Access Toolbar?
Frequently used commands like Save, Undo, and Redo.
91
Multiple Choice: Which of the following can you NOT do in the Insert tab? A) Insert a chart B) Insert a hyperlink C) Insert a comment D) Insert a picture
C) Insert a comment
92
What is the purpose of the Format Painter tool?
To copy formatting from one part of the document and apply it to another.
93
True or False: The Review tab includes options for adding comments and tracking changes.
True
94
Which tab would you use to change the line spacing of paragraphs?
Home
95
What is the function of the Page Setup dialog box?
To customize settings such as paper size, orientation, and margins.
96
Fill in the blank: The _____ tab is used to create tables within a document.
Insert
97
What does the View tab allow you to do regarding document navigation?
It allows you to open the Navigation Pane for easier document browsing.
98
Multiple Choice: Which of these features is found under the Review tab? A) Thesaurus B) Page Break C) Text Box D) Shape
A) Thesaurus
99
What is the purpose of the Sizing handles in MS Word 2013?
To resize images and other objects within the document.
100
True or False: The Help tab provides access to online resources and support.
True
101
Which tab contains options for setting up columns in a document?
Page Layout
102
Fill in the blank: The _____ tab is where you can find the option to change the document's theme.
Design
103
What does the SmartArt feature in the Insert tab do?
It allows users to create diagrams to visually represent information.
104
What is the function of the Undo button?
To reverse the last action taken in the document.

E-Tech (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions