Question 1
(TCO 8) Which of the following is a not an Excel file type?
    .xls
    .xlsx
    text file
    .xltm
 

Question 2
(TCO 8) Which of the following file types use commas to separate data into columns.
    jpeg
    pdf
    csv
    tab-delimited
 

Question 3
(TCO 8) Where are web query tools and options located?
    Formulas tab
    Insert tab
    Data tab
    Review tab
 

Question 4
(TCO 8) Which of the following are settings that control how imported data in cells connect to their source data?
    Import settings
    Connection properties
    Link settings
    Data range properties
 

Question 5
(TCO 8) Using the Convert Text to Columns Wizard is similar to using the _____.
    Style Sheet
    Formatting toolbar
    Text Import Wizard
    Customize Date feature
 
 

Question 6
(TCO 8) ) Which of the following functions does not manipulate text?
    CONCATENATE
    PROPER
    UPPER
    INDEX
 

Question 7
(TCO 8) Which of the following is an alternative to using the CONCATENATE function?
    &
    +
    SUM
    :
 

Question 8
(TCO 8) What governing body created XML?
    IEEE
    World Wide Web Consortium
    The Computer Science Society
    ICANN
 

Question 9
(TCO 7) Which of the following is not a tool to improve efficiency in a common workbook that is used by numerous employees in a business?
    Template
    Macros
    Themes
    Print settings
 

Question 10
(TCO 7) Where is the Insert Background feature located?
    Backstage
    Page Layout tab
    Formulas tab
    Insert tab
 
 
 

Question 11
(TCO 7) Which of the following is not controlled with cell style formats?
    Font attributes
    Print settings
    Cell-protection settings
    Border and fill styles
 

Question 12
What is the default save location for templates?
    C:\Users\username\Documents\CustomOfficeTemplates
    C:\Users\MyDocuments
    C:\templates
    C:\Users\templates
 
 
 

Question 13
(TCO 7) Which of the following is true about a protected worksheet?
    It cannot be saved.
    It cannot be printed.
    It cannot be edited.
    It cannot be shared on SkyDrive.
 

Question 14
(TCO 7) Which of the following tools is best suited to complete repetitive tasks in Excel?
    Macros
    Templates
    Styles
    Themes
 

Question 15
(TCO 7) Which of the formats below will not support sub procedures using VBA?
    .xlsm
    .xlsx
    xlsb
    xltm

ComputerScienceExpert

(11)

Status NEW Posted 10 Dec 2017 05:12 PM My Price 7.00

-----------

Attachments

file 1512927864-BIS 155 Week 7 Quiz.docx preview (279 words )

Q-----------ues-----------tio-----------n 1----------- -----------(TC-----------O 8-----------) W-----------hic-----------h o-----------f t-----------he -----------fol-----------low-----------ing----------- is----------- a -----------not----------- an----------- Ex-----------cel----------- fi-----------le -----------typ-----------e? ----------- .x-----------ls.-----------xls-----------xte-----------xt -----------fil-----------e -----------.xl-----------tmQ-----------ues-----------tio-----------n 2----------- -----------(TC-----------O 8-----------) W-----------hic-----------h o-----------f t-----------he -----------fol-----------low-----------ing----------- fi-----------le -----------typ-----------es -----------use----------- co-----------mma-----------s t-----------o s-----------epa-----------rat-----------e d-----------ata----------- in-----------to -----------col-----------umn-----------s. ----------- jp-----------eg ----------- pd-----------fcs-----------vta-----------b-d-----------eli-----------mit-----------ed ----------- Q-----------ues-----------tio-----------n 3----------- -----------(TC-----------O 8-----------) W-----------her-----------e a-----------re -----------web----------- qu-----------ery----------- to-----------ols----------- an-----------d o-----------pti-----------ons----------- lo-----------cat-----------ed?----------- F-----------orm-----------ula-----------s t-----------ab ----------- In-----------ser-----------t t-----------ab ----------- Da-----------ta -----------tab----------- R-----------evi-----------ew -----------tab----------- Q-----------ues-----------tio-----------n 4----------- -----------(TC-----------O 8-----------) W-----------hic-----------h o-----------f t-----------he -----------fol-----------low-----------ing----------- ar-----------e s-----------ett-----------ing-----------s t-----------hat----------- co-----------ntr-----------ol -----------how----------- im-----------por-----------ted----------- da-----------ta -----------in

Not Rated(0)

• Buy Answer