A
You insert a table in PowerPoint and then apply a table style. What does the style change?
A) Borders, fill colors, and the header row formatting
B) Only the text inside the table cells
C) Only the thickness of the borders
A) Borders, fill colors, and the header row formatting
You make a data entry form using the Form Wizard. Later, you add a new column to your table. What happens to the form?
A) The new column does not show up unless you add it yourself
B) The new column shows up on its own
C) The form gets deleted and you have to start over
A) The new column does not show up unless you add it yourself
You create a section group and put several sections inside it. Can you put a password directly on the section group itself?
A) Yes, you can protect a section group
B) No, you can only protect individual sections
C) Yes, but the password applies only to new sections
B) No, you can only protect individual sections
In PowerPoint if you manually change the font color of a title and then apply a new theme, what happens to that title?
A) It stays your manual color
B) It changes to the theme's color
C) It becomes white
A) It keeps your color
True or False: A table in Microsoft Access can only have one primary key, and it must be just one column.
False
You put a password on a section in OneNote. What does the password protect?
A) All pages inside that section
B) Only the first page of that section
C) The whole notebook
C) The whole notebook
You use =VLOOKUP(1001, A2:C100, 3, FALSE) to find an exact match. If the value 1001 is not found in column A, what error does the formula show?
A) #REF!
B) #N/A
C) #VALUE!
B) #N/A
If two conditional formatting rules conflict on the same cell, which one takes priority?
A) The one higher in the Rules Manager
B) The one lower in the list
C) The one created first
A) The one higher in the Rules Manager
You share a notebook with someone and give them "view-only" access. What can they still do?
A) Look at everything, including tags
B) Add new To Do checkboxes
C) Insert new pictures
C) Insert new pictures
You use VLOOKUP with "approximate match" (TRUE). What must you do to the first column of your table?
A) Sort it from smallest to largest
B) Make sure it only has numbers
C) Make sure it has no empty cells
C) Make sure it has no empty cells
Can you import an Excel file into an Access table that already has data?
A) Yes, you can append the data
B) No, you must import into a new table only
C) Yes, but only if the columns match exactly
C) Yes, but only if the columns match exactly
If you receive an email and want to send it to a new person without including the original sender, which option do you use?
A) Forward
B) Reply
C) Reply All
A) Forward
You have a list of products in column A and prices in column B. You use =VLOOKUP("Pen", A:B, 2, FALSE). If "Pen" appears three times, what does the formula give you?
A) The price from the first matching row
B) The price from the last matching row
C) The average of all the prices
A) The price from the first matching row
What is the main purpose of a foreign key in an Access database?
A) To create a unique ID for each record
B) To link records in one table to records in another table
C) To sort data alphabetically
B) To link records in one table to records in another table
If you move a page to a different section, do its tags move with it?
A) Yes, tags stay with the page
B) No, tags are removed
C) Only if you copy and paste
A) Yes, tags stay with the page
Which of these is an input device?
A) Monitor
B) Microphone
C) Printer
B) Microphone