MS word & excel Flashcards
What is a formula in Excel?
A formula in Excel is an expression that calculates the value of a cell.
True or False: Formulas in Excel always start with the equal sign (=).
True
Fill in the blank: The function used to sum a range of cells is called _____.
SUM
What is the purpose of the AVERAGE function in Excel?
To calculate the average of a set of numbers.
Which function would you use to find the maximum value in a range?
MAX
What does the COUNT function do?
It counts the number of cells that contain numbers in a range.
True or False: You can use cell references in Excel formulas.
True
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.
What is the syntax for the IF function?
IF(logical_test, value_if_true, value_if_false)
Which function would you use to concatenate text strings?
CONCATENATE or the ‘&’ operator.
Fill in the blank: The function to find the current date is _____.
TODAY()
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.
True or False: The PMT function is used to calculate loan payments.
True
What is the purpose of the ROUND function?
To round a number to a specified number of digits.
Which function would you use to count non-empty cells?
COUNTA
Fill in the blank: The formula to calculate the percentage increase is _____.
(New Value - Old Value) / Old Value
What does the LEN function do?
It returns the number of characters in a text string.
What is the purpose of the INDEX function?
To return the value of a cell in a specified row and column of a range.
True or False: You can nest functions within other functions in Excel.
True
What is the function of the CONCAT function?
To join multiple text strings into one string.
What does the NOW function return?
The current date and time.
Fill in the blank: The function used to find the smallest number in a range is _____.
MIN
What is the syntax for the SUMIF function?
SUMIF(range, criteria, [sum_range])
What does the MATCH function do?
It returns the relative position of an item in an array that matches a specified value.
True or False: The TODAY function updates every time the worksheet is recalculated.
True
What is the purpose of the IFERROR function?
To return a custom value if a formula results in an error.
What is a formula in Excel?
A formula in Excel is an expression that calculates the value of a cell.
True or False: Formulas in Excel always start with the equal sign (=).
True
Fill in the blank: The function used to sum a range of cells is called _____.
SUM
What is the purpose of the AVERAGE function in Excel?
To calculate the average of a set of numbers.
Which function would you use to find the maximum value in a range?
MAX
What does the COUNT function do?
It counts the number of cells that contain numbers in a range.
True or False: You can use cell references in Excel formulas.
True
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.
What is the syntax for the IF function?
IF(logical_test, value_if_true, value_if_false)
Which function would you use to concatenate text strings?
CONCATENATE or the ‘&’ operator.
Fill in the blank: The function to find the current date is _____.
TODAY()
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.
True or False: The PMT function is used to calculate loan payments.
True
What is the purpose of the ROUND function?
To round a number to a specified number of digits.
Which function would you use to count non-empty cells?
COUNTA
Fill in the blank: The formula to calculate the percentage increase is _____.
(New Value - Old Value) / Old Value
What does the LEN function do?
It returns the number of characters in a text string.
What is the purpose of the INDEX function?
To return the value of a cell in a specified row and column of a range.
True or False: You can nest functions within other functions in Excel.
True
What is the function of the CONCAT function?
To join multiple text strings into one string.
What does the NOW function return?
The current date and time.
Fill in the blank: The function used to find the smallest number in a range is _____.
MIN
What is the syntax for the SUMIF function?
SUMIF(range, criteria, [sum_range])
What does the MATCH function do?
It returns the relative position of an item in an array that matches a specified value.
True or False: The TODAY function updates every time the worksheet is recalculated.
True
What is the purpose of the IFERROR function?
To return a custom value if a formula results in an error.
What function would you use in Excel to convert text to lowercase?
LOWER
True or False: The CONCATENATE function can combine multiple text strings into one.
True
Fill in the blank: The function __________ is used to find the length of a text string.
LEN
What does the TEXT function do in Excel?
It formats a number and converts it to text.
Which function would you use to extract a specific number of characters from the start of a text string?
LEFT
Multiple Choice: Which of the following functions returns a substring from a text string? A) MID B) SUM C) AVERAGE D) IF
A) MID
What is the purpose of the TRIM function in Excel?
To remove extra spaces from text.
True or False: The UPPER function converts all characters in a text string to uppercase.
True
What logical function would you use to test a condition and return one value if true and another if false?
IF
Fill in the blank: The function __________ checks whether a condition is met and returns TRUE or FALSE.
BOOLEAN
Which logical function can be used to return TRUE if all conditions are true?
AND
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
What does the NOT function do in Excel?
It reverses the logical value of its argument.
True or False: The COUNTIF function can be used to count the number of cells that meet a certain condition.
True
What is the syntax for the IF function in Excel?
IF(logical_test, value_if_true, value_if_false)
Fill in the blank: The __________ function can be nested within an IF function to provide additional logical tests.
AND/OR
Which function would you use to check if a specific text string is found within another text string?
SEARCH
What is the purpose of the FIND function in Excel?
To locate a substring within a text string, case-sensitive.
True or False: Excel’s IFERROR function can be used to handle errors in calculations.
True
What does the ISBLANK function check?
It checks whether a cell is empty.
Multiple Choice: Which function would you use to combine text from different cells? A) CONCATENATE B) SPLIT C) JOIN D) TEXTJOIN
A) CONCATENATE
What is the output of the formula =IF(1=1, ‘Yes’, ‘No’)?
Yes
Fill in the blank: The __________ function is used to join multiple text strings with a specified delimiter.
TEXTJOIN
Which function returns the number of characters in a text string, including spaces?
LEN
True or False: The SUBSTITUTE function can replace a specific instance of a substring within a text string.
True
What does the VALUE function do in Excel?
It converts a text string that represents a number into a numeric value.
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.
True or False: The Insert tab allows users to add images and tables to their document.
True
Fill in the blank: The _____ tab contains options for page layout, including margins and orientation.
Page Layout
Which tab would you use to check the spelling and grammar of a document?
Review
What feature can you find under the View tab?
Options to change the document’s view, such as Print Layout, Web Layout, and Outline.
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
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.
True or False: The File tab is where you can save, open, and print documents.
True
Which submenu in the Page Layout tab allows you to adjust the document’s margins?
Margins submenu
What is the purpose of the Mailings tab?
To create and manage mail merge documents for mass mailings.
Fill in the blank: The _____ tab provides tools for working with references and citations.
References
What can you find in the Quick Access Toolbar?
Frequently used commands like Save, Undo, and Redo.
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
What is the purpose of the Format Painter tool?
To copy formatting from one part of the document and apply it to another.
True or False: The Review tab includes options for adding comments and tracking changes.
True
Which tab would you use to change the line spacing of paragraphs?
Home
What is the function of the Page Setup dialog box?
To customize settings such as paper size, orientation, and margins.
Fill in the blank: The _____ tab is used to create tables within a document.
Insert
What does the View tab allow you to do regarding document navigation?
It allows you to open the Navigation Pane for easier document browsing.
Multiple Choice: Which of these features is found under the Review tab? A) Thesaurus B) Page Break C) Text Box D) Shape
A) Thesaurus
What is the purpose of the Sizing handles in MS Word 2013?
To resize images and other objects within the document.
True or False: The Help tab provides access to online resources and support.
True
Which tab contains options for setting up columns in a document?
Page Layout
Fill in the blank: The _____ tab is where you can find the option to change the document’s theme.
Design
What does the SmartArt feature in the Insert tab do?
It allows users to create diagrams to visually represent information.
What is the function of the Undo button?
To reverse the last action taken in the document.
