Oxford University (OX)

workbook a file which contains one or more spreadsheets spreadsheet an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical form cells individual locations on a spreadsheet cell address refers to one specific location; Cell A4 cell range refers to a group of adjacent cells; A4:A16 label classification is used for cells that contain text or for numbers that will not be used in calculati...

Sort table in ascending order. Table Tools > Layout > Sort Configure table so headings repeat on next page. Table Tools > Layout > Data > Repeat Header Row Create a table from text. Spread it across the entire width of the document. Insert > Table > Convert to Table > Auto Fit to Window Add a footnote. References > Insert Footnote` Cut and paste text. Home > Cut > Paste Add a diagram (SmartArt - Basic Chevron Process) Inse...

Sort table in ascending order. Table Tools > Layout > Sort Configure table so headings repeat on next page. Table Tools > Layout > Data > Repeat Header Row Create a table from text. Spread it across the entire width of the document. Insert > Table > Convert to Table > Auto Fit to Window Add a footnote. References > Insert Footnote` Add text "Draft" to the status property File > Properties > Advanced Properties > Status ...

How is the default timescale in Microsoft Project 2016 arranged? By weeks and days. What is the default view (screen) in Microsoft Project? The Gantt Chart view. What criteria do you use when entering tasks in Microsoft Project? Enter them in order of occurrence. What is the default calendar in Microsoft Project? The Project calendar. Which element of the triple constraint typically can't be changed for a surprise 50th-birthday-party project? Time. What o...

Ribbon A set of toolbars at the top of the window in Office programs designed to help you quickly find the commands that you need to complete a task. Cut The icon on the Home ribbon that will "cut" the selected text or object. Copy The icon on the Home ribbon that will "copy" the selected text or object. Paste The icon on the Home ribbon that will "paste" the selected text or object that has been cut or copied and is available on the clipboard. Line Spacing The ico...

Cloud Identity Model user is created and managed in M365 and stored in Azure AD; password is verified by Azure AD Synchronized Identity Model user is managed in an on-premises server, and accounts and password hashes are synced to the cloud Federated Identity Model requires synced identity where user password is verified by on-premises provider Where does data in Teams reside? geographic region associated with the tenant TF: Without SharePoint and/or OneDrive, you...

the first screen displayed when you open word 2016 is called the recent screen which of the following contains the commands you use most often, such as save, undo, and repeat quick access toolbar The headings that appear on the ribbon, such as file, home, and insert, are called tabs which command is used to save a document for the first time save or save as which of the following options is used when saving a document with a new filename save as when you s...

If a newly created chart appears to have the data on the vertical and horizontal axes switched, what charting feature can fix this mix-up? Switch Row/Column. What combination of actions makes creating a chart a simple task? Select the numbers and labels you want to use in your chart, click the Quick Analysis option, and choose one of several recommended chart types. Which option on the Chart Tools Format tab is your saving grace if you want a custom-formatted chart element to r...

document Nathan is using a business letter template he created earlier and wants to save it with all the customer information in place. What file type should he select? template Shameka is a yearbook staff member. Every semester she has to create a newsletter. Instead of recreating it each time, what should she create for future use? newsletter What type of template is most appropriate for an FBLA Secretary to use to inform FBLA members of monthly club activities? Is the ...

Microsoft Certification exam study guide |60 questions with verified correct answers.