Data entry Operator / Skills Test V3

What does a red triangle in the top right corner of a cell indicate in a spreadsheet?

You can also customize the __________ by going to the Design tab, which is located next to the Insert tab.

What is the specific keyboard shortcut to select all cells in a column within a Microsoft Excel worksheet?

Which key or combination of keys is used to navigate to the ‘Goto’ tab in MS Excel, where you can go to a specific cell, sheet, or workbook location?

What is the name of the Office 365 feature that allows you to create, edit, and share documents, presentations, and spreadsheets online?

What is the name of the Office 365 service that allows for real-time collaboration and co-authoring on documents?

What tool in Microsoft PowerPoint should be used to ensure that all slides in a presentation have a consistent appearance?

Can you download a Google Docs document in other file formats?

What is a conditional formatting rule in a spreadsheet?

How can you protect specific cells in a Google Sheet so that they cannot be edited?

How can you add a hyperlink to text in Google Slides?

What is the name of the Office 365 feature that allows you to share and collaborate on documents and files with team members, and also includes features such as version control and workflow management?

________ in Excel provide a more powerful and flexible way to filter data, allowing you to filter by multiple conditions, and also allowing you to extract specific data to a new location but not used to create charts and graphs, perform calculations or merge cells.

What is the task related to altering the visual format of a document within the context of word processing?

What type of documents can be created using Microsoft Word?

How can you add a drop-down list to a cell in a spreadsheet?

Can you use Google Forms to create a form that can automatically create a document based on the user’s response?

Which key combination is used to navigate to the previous field while working in Google Forms?

What is the purpose of using a spreadsheet?

_______ are typically used to show trends in data over time and are typically inserted into a cell in a worksheet, rather than on a separate chart sheet.

What is the keyboard shortcut used to shift a selected paragraph upward in Microsoft Word 2022 version?

What function is used to find the average of a range of cells in Microsoft Excel?

How can you select a group of non-adjacent cells in Microsoft Excel?

How can you add a progress bar to a Google Form to show the user how many questions have been completed and how many remain?

What is the shortcut key for creating a new slide in Google Slides?

What is the most popular spreadsheet program used for data analysis and manipulation?

What is the key feature of a spreadsheet that allows us to quickly perform complex calculations?

What is the keyboard shortcut for quickly accessing a particular element, such as a page, bookmark, footnote, table comment, graphic, or other item, within MS Word 2022?

What is the function and utility of the ruler feature in the Microsoft Word application?

What are the various techniques that can be employed to introduce a section break within a document created using Microsoft Word software?

What is the feature in Microsoft Word that automatically moves text to the next line when the current line is full?

How can you add an animation to an object in Google Slides?

You can add _______ to specific text or images to make it easy for your audience to access additional information.

PowerPoint which feature user to apply motion effects to different objects of a slide is:

What is the keyboard shortcut for relocating a chosen section of text one step below its current position in MS Word 2020?

What is the keystroke or combination of keystrokes that can be employed to rapidly navigate to the last entry in a table in Microsoft Excel?

How can you access your Google Drive files from a different device?

How can you make a question in a Google Form required to be answered before a user can submit the form?

How do you apply a theme to a Google Slides presentation?

Which of the following option allows you to protect your worksheet from accidental changes by password-protecting it and setting which cells can be edited?

In Excel 2019, when needing to apply more than two conditions or analyze a list using database functions, which filter will be used?

How can We modify the information in an Excel spreadsheet that is embedded in a Word document?

What is the standard orientation for slide page layout in a PowerPoint presentation?

How can you share a Google Form with others?

What is the procedure to use Google form offline?

How do you change the font size of text in a Google Slides presentation?

What is the purpose of using a filter in a spreadsheet program?

Is it possible to use Google Sheets to create a macro that automates repetitive tasks?

Which of the following is not a required element to successfully execute a mail merge operation?

In powerpoint, How can I insert slides from another presentation into the current one I have selected?

Which of the following is not a view option offered by PowerPoint to examine and alter a presentation?

Can we create a Google Form that allows users to submit multiple responses?

_____________ in Excel can be used to analyze business data in various ways.

A _________ program is used for data analysis and manipulation, while a database program is used for storing and organizing large amounts of structured data.

In Microsoft Word, which menu option allows for the insertion of various elements such as pictures, text boxes, and charts?

Which of the following Excel interface components cannot be toggled on or off?

What is the best way to display text and numerical information in Microsoft PowerPoint?

Which view option is not provided by PowerPoint for viewing and modifying a presentation?

In the Microsoft Office Suite, what term is used to refer to a collection of related commands that are grouped together for easy access and organization?

What is the method add a trendline to a graph in Google Sheets?

What significance does the EXT indicator on the status bar of MS Word hold?

You’re working in spreadsheet and want to import data into a spreadsheet program?

Can we create a Google Form with multiple pages?

What are the different types of data that can be input into the cells of a worksheet in a spreadsheet application such as Excel?

How can you quickly remove duplicates in an Excel sheet?

Which among the following options is not a valid data type that can be used in Excel for storing and manipulating information?

In a MS Word document, where is the endnote located in relation to the main body of the text?

How can you add a filter to a table in a Google Sheets document?

Which operating system is specifically designed and developed to cater to the needs and requirements of only one user at a time, as opposed to being used by multiple users simultaneously?

What is the method used to refer to a specific cell in a formula when working with a spreadsheet?

Suppose, You closed the spreadsheet. Can you access previous versions of a Google Drive file?

What should be clicked to keep the row and column titles in place while scrolling through a worksheet?

How can you automatically adjust the width of a column in Excel to fit the contents of its cells?

Which of the following is NOT a feature of Google Forms?

How can you customize the confirmation message that is shown to users after they submit a Google Form?

Which of the following option is correct to apply a formula to a range of cells in a Google Sheets document?

Which of the following option is correct to change the font style in a Google Doc?

What is the process of copying a formula from one cell to another called?

Can you store Google Drive files in a folder for collaborative work with team members?

What is the term used to refer to the view that presents the slides of a presentation as miniature versions of the slides themselves?

What happens to a Google Docs document if the owner of the document deletes their Google account?

How can you wrap text in a cell in Microsoft Excel to display text on multiple lines within the cell?

How can you create a “paragraph text” question in a Google Form?

What feature in MS Excel allows for the efficient input of repetitive data into a worksheet?

You’re working in spreadsheet and want to customize the ribbon in Microsoft Office?

What are the two types of data that can be entered into a spreadsheet?

What is the main function of a spreadsheet in an office suite?

How can you create a chart in Microsoft Excel?

By clicking the _______ button in the “Data” tab and selecting “Data Validation” you create a drop-down list in Microsoft Excel.

Which of the following method can be used to add a section break in a Google Form?

Can MS-EXCEL be utilized to automate repetitive and time-consuming tasks, thereby increasing productivity and efficiency?

______ option allows you to automatically create a table of contents based on the headings in your document.

Documents you create using Google Slides are stored:

How do you apply a formula to an entire column in Microsoft Excel?

You’re working in spreadsheet and want to sort data. How can you sort data in a spreadsheet?

what is the function of “Sort & Filter” in excel?

What is the maximum number of choices allowed in a multiple choice question in Google Forms?

Which key in a spreadsheet can be used to arrange data in a worksheet in a clear and organized manner?

What program in Microsoft Office is used for creating and editing documents?

In Google slides, What is the fastest way to change all of the slide layouts and colors of your presentation?

How do you add a border to cells in Microsoft Excel?

What is the key combination or function used to navigate the cursor to the beginning of the next word in Microsoft Word?

________ in Microsoft Word allow you to quickly change the overall design of a document by applying a consistent set of colors, fonts, and effects to the entire document. Themes can be accessed from the Design tab.

Suppose, You’re creating the test in Google form and want to check the responses. How can you view the responses to a Google Form?

What is the name of the point where a column and a row meet on a worksheet?

What is the name of the Office 365 feature that allows you to create and manage custom forms and surveys?

Google Slides is most similar to which of the following programs?

What is the formula to calculate the sum of the squares of a range of cells in a spreadsheet?

What is the terminology used to describe the collection of commands found within the Microsoft Office software package?

The ________ feature in Microsoft Word allows multiple users to collaborate on a document and track the changes made by each user.

How can you create a spreadsheet of the responses to a Google Form?

______ key combination that can be used as a shortcut to concatenate or link multiple cells of text together in a Google Sheets document?

Which Office 365 plan includes the ability to install the Office applications on up to five PCs or Macs?

How often are updates and new features released for Microsoft Office 365?

What is the formula to calculate the maximum value in a range of cells in a spreadsheet?